set ANSI_NULLS ON
set QUOTED_IDENTIFIER OFF
GO

create proc [dbo].[SP_GET_CATE_ID]
(
	@SERCAT_ID int
)
as

select * from dbo.SERVICES,dbo.SERVICE_CATEGROIES
where dbo.SERVICES.SERCAT_ID =dbo.SERVICE_CATEGROIES.SERCAT_ID
and dbo.SERVICES.SERCAT_ID =@SERCAT_ID